OneDriveCredits: 2
| Instructor | |
| Name: | Brent Presley |
| (see Brent's Schedule) | |
| Office: | Stevens Point Campus, Faculty Offices |
| Phone: | 295-1272 |
| E-Mail: | brent.presley@mstc.edu |
| Textbooks | |
| Title: | Database Design for Mere Mortals |
| Author: | Hernandez |
| Publisher: | Pearson-Addison-Wesley |
| Year/Edition: | 3rd Edition |
| ISBN: | 9780321884497 |
| Title: | A Guide to MySQL |
| Author: | Pratt, Last |
| Publisher: | Course Technology |
| Year/Edition: | 2006 |
| ISBN: | 1418836354 |
| Prerequisites | |
| Course & Course Number | Alternative |
|---|---|
| Programming Logic - Intermediate (152-102) | Instructor Permission |
| Required Student Materials | ||
| Item | Quantity | Approximate Cost |
|---|---|---|
| USB Storage Drive | 1 | Optional - Price varies with capacity |
Course Description
Covers the concepts of relational database design, development
and maintenance. Topics include relational normalization,
referential integrity, SQL, proper use of indexing, and stored procedures.
Course Competencies
- Define basic relational database terminology
- Describe the relational database model
- Design and normalize a multi-table database
- Create an ERD for a database
- Use Structured Query Language (SQL) to
- Create tables
- Insert data
- Construct queries involving only 1 table
- Construct queries involving multiple tables
- Update and delete data
- Set up security for a database
- Use SQL stored procedures (time permitting)
Course Outline
- Database Fundamentals & the Relational Model
(Database Design for Mere Mortals)- Introduction to Database Management
- The Relational Model
- Database Design (Database Design for Mere Mortals)
- Normalization
- Design Methodology, ERDs and UML diagrams
- SQL Programming (A Guide to MySQL)
- Introduction
- Data Definition
- Single Table Queries
- Multiple Table Queries
- Updating Structure and Data
- Database Administration: indexes and privileges
- Stored Procedures
Student Assignments
- Read textbook
- Participate in lecture/discussion
- Complete homework assignments
Course Grading
I will assign a letter grade for the course based on the following overall percentages:
| A | 95 - 100% |
| A- | 93 - 94% |
| B+ | 90 - 92% |
| B | 88 - 89% |
| B- | 86 - 87% |
| C+ | 83 - 85% |
| C | 80 - 82% |
| D | 70 - 79% |
| F | Below 70% |
Note: This course may be a prerequisite for other courses at MSTC. MSTC policy (see the handbook) states you must earn at least a C in a prerequisite course to enroll in the subsequent courses.
Employability Skills
In addition to the material required in this course, the course will also further develop your skills in the following MSTC Core Abilities:
- Act with integrity
- Communicate effectively
- Demonstrate effective critical and creative thinking
- Demonstrate global and social awareness
- Use Appropriate Technology
Academic Integrity Policy
The Mid-State Technical College Board, administration, faculty, and staff believe that academic honesty and integrity are fundamental to the mission of higher education. All students are expected to maintain and promote the highest standards of personal honesty and professional integrity. These standards apply to all examinations, assigned work, and projects. Therefore, a student who is found to have been dishonest, fraudulent, or deceptive in the completion of work or willing to help others to be so or who is found to have plagiarized (presented the work of others as his or her own) is subject to disciplinary action up to and including suspension.
Brent's clarification of the above:
Homework assignments for this course are completed entirely on disks which unfortunately are easy to copy. If I determine that two assignments are identical, I will interview both students in an attempt to determine who did the copying. If I can determine who copied, I will give that student a zero on the assignment and let other instructors know of the infraction. If I determine a student has copied a second time, I will immediately fail (fail, not withdraw) that student in this course.
Course Expectations
I will take attendance only for record keeping purposes--your grade is not affected by your attendance. On the other hand, I will not repeat a lecture for someone who misses a class. It is your responsibility to make up the work you missed. Get to know your classmates and ask them to help you catch up. If you miss a lecture, come to class early the next day and get a copy of the examples done in class either from a fellow student or the instructor so you will be prepared for the next lecture. Review the notes on the web site.
If you decide you no longer wish to attend this class, it is your responsibility to drop the class. I will not drop students who are no longer attending. If you don’t drop the course, you will receive a grade of “F”.
Classroom Environment
I attempt to create a classroom environment that is comfortable for learning. If I inadvertently say or do something that offends or hurts you, please tell me (preferably after class) so I can correct the problem. If another student offends you, tell that student how you feel as well. If that doesn't solve the problem, tell me. In order for our labs to be comfortable, productive environments, please do not use the computer to view inappropriate material that might be offensive to others. If you see others abusing their lab computer privileges, report them to your instructor or any other MSTC staff member.
Learning can be difficult enough as it is. Help me ensure the classroom and lab is an untroubled place to learn.
Recording Lectures
I record all my lectures and post them to my Web site (usually the same day). If you wish, you may make your own recording of my lecture, following these terms:
You must complete the Recording Audio/Video Agreement Form BEFORE audio/video recording a lecture.
With prior approval, students may be allowed to audio/video record lectures to enhance their
understanding of the topics presented. Audio/video recordings are not substitutes for attending class.
If you choose to record lectures, you must sign an agreement which lists the following terms:
- Recordings are not to be distributed without the permission of the instructor. This includes sharing via the Internet, peer to peer file sharing, or other methods.
- Recordings are not to be shared with other classmates unless they are to be used in collaborative assignments, or if the instructor approves sharing for other reasons.
- You will turn off recorders at the request of instructor.
Non-compliance with these terms violates an instructor's intellectual property rights. Students violating this agreement will be subject to disciplinary actions under the Student Code of Conduct.
Special Needs
If you know you have a recognized disability, or suspect that you might have one, it is your responsibility to identify yourself as soon as possible to the Disability Services staff in Student Affairs. Course standards will not be lowered but various kinds of accommodations are available to you. Adequate and reasonable time will be required to develop and provide appropriate accommodations, so contact Disability Services as soon as possible. It is MSTC's goal to assist you in your individual educational plan.
If you have an illness (e.g. epilepsy, diabetes) or allergy you feel I should know about, please let me know.
If you have other circumstances (family, job, etc) that might affect your performance in this class, please let me know. We might be able to make accommodations to help ensure your success.
